package com.pai.dao.Personnel;



import com.pai.entity.Personnel;

import java.sql.Connection;
import java.util.List;

public interface PersonnelDao {
    /**
     * 获取列表
     * @param connection
     * @return
     * @throws Exception
     */
    public List<Personnel> getList(Connection connection) throws Exception;


    /**
     * 获取列表
     * @param connection
     * @param departmentId  部门id
     * @param depName 部门名称
     * @param perName 人员名称
     * @return
     * @throws Exception
     */
    public List<Personnel> getList(Connection connection, String departmentId, String depName, String perName) throws Exception;

    /**
     * 获取学生列表
     * @param connection
     * @param parentDepId  二级学院id
     * @return
     * @throws Exception
     */
    public List<Personnel> getStudentList(Connection connection, String parentDepId) throws Exception;
    public List<Personnel> getStudentListCol(Connection connection, String colId) throws Exception;
    /**
     * 获取项详情
     * @param connection
     * @param id
     * @return
     * @throws Exception
     */
    public Personnel getItemDetail(Connection connection, String id) throws Exception;
    /**
     * 新增
     * @param connection
     * @param item
     * @return
     * @throws Exception
     */
    public int add(Connection connection, Personnel item) throws Exception;




    /**
     * 更新
     * @param connection
     * @param item
     * @return
     * @throws Exception
     */
    public int update(Connection connection, Personnel item) throws Exception;


    /**
     * 删除
     * @param connection
     * @param id
     * @return
     * @throws Exception
     */
    public int delete(Connection connection, String id) throws Exception;
}
